#!/bin/sh

USERNAME="root"
echo "Enter your ROOT password here: "
read PASSWORD

mysql -u$USERNAME -p$PASSWORD < createCoffeeShopSchema.sql
echo "Create coffee_shop schema successfully."

mysql -u$USERNAME -p$PASSWORD coffee_shop < importCoffeeShopDB.sql
echo "Import columns and data of coffee_shop schema successfully."

echo "Import Successfully!"
